USE [texchange_db]
GO

/****** Object:  StoredProcedure [dbo].[SP_InsPlace]    Script Date: 05/29/2011 19:48:13 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE proc [dbo].[SP_InsPlace] 
  @short  nvarchar(20) = '',
  @name  nvarchar(100) = '',
  @placetype_id bigint,
  @isActive bit = 1,
  @country_id bigint = null
as
	INSERT INTO Places (short, [name], placetype_id, isActive, country_id) VALUES(@short, @name, @placetype_id, @isActive, @country_id)

Select @@Identity as lastID

SET NOCOUNT OFF


GO


